Hệ thống quản lý chứng khoán Dự án Java

19.533 lượt xem;
1 -- phpMyAdmin SQL Dump
2 -- version 2.11.6
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: localhost
6 -- Generation Time: Mar 11, 2010 at 04:24 AM
7 -- Server version: 5.0.51
8 -- PHP Version: 5.2.6
9
10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16 /*!40101 SET NAMES utf8 */;
17
18 --
19 -- Database: `stock`
20 --
21
22 -- --------------------------------------------------------
23
24 --
25 -- Table structure for table `category_details`
26 --
27
28 CREATE TABLE `category_details` (
29   `id` int(10) unsigned NOT NULL auto_increment,
30   `category_name` varchar(120) NOT NULL,
31   `category_description` varchar(250) NOT NULL,
32   PRIMARY KEY (`id`)
33 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
34
35 --
36 -- Dumping data for table `category_details`
37 --
38
39 INSERT INTO `category_details` (`id`, `category_name`, `category_description`) VALUES
40 (5, 'category1', ''),
41 (6, 'category2', ''),
42 (7, 'category3', ''),
43 (8, 'category4', ''),
44 (9, 'category6', ''),
45 (10, 'category7', ''),
46 (11, 'category8', ''),
47 (12, 'category9', ''),
48 (13, 'category10', ''),
49 (14, 'category11', ''),
50 (15, 'category18', ''),
51 (16, '', ''),
52 (17, 'newcategory', '');
53
54 -- --------------------------------------------------------
55
56 --
57 -- Table structure for table `customer_details`
58 --
59
60 CREATE TABLE `customer_details` (
61   `id` int(10) unsigned NOT NULL auto_increment,
62   `customer_name` varchar(200) NOT NULL,
63   `customer_address` varchar(500) NOT NULL,
64   `customer_contact1` varchar(100) NOT NULL,
65   `customer_contact2` varchar(100) NOT NULL,
66   `balance` int(11) NOT NULL,
67   PRIMARY KEY (`id`)
68 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
69
70 --
71 -- Dumping data for table `customer_details`
72 --
73
74 INSERT INTO `customer_details` (`id`, `customer_name`, `customer_address`, `customer_contact1`, `customer_contact2`, `balance`) VALUES
75 (3, 'customer1', 'customer1 address', '9953938493', '9874983579', 0),
76 (4, 'customer245', 'customer2 address', '489758437', '98479857389', 0);
77
78 -- --------------------------------------------------------
79
80 --
81 -- Table structure for table `stock_avail`
82 --
83
84 CREATE TABLE `stock_avail` (
85   `id` int(10) unsigned NOT NULL auto_increment,
86   `name` varchar(120) NOT NULL,
87   `quantity` int(10) unsigned NOT NULL,
88   PRIMARY KEY (`id`)
89 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
90
91 --
92 -- Dumping data for table `stock_avail`
93 --
94
95 INSERT INTO `stock_avail` (`id`, `name`, `quantity`) VALUES
96 (3, 'stock1', 0),
97 (4, 'stock2', 0),
98 (5, 'stock3', 1243),
99 (7, 'fhadsjfds', 567),
100 (9, 'stock4', 0),
101 (10, 'stock5', 230),
102 (11, 'stock6', 457),
103 (12, 'stock7', 555),
104 (13, 'stock8', 0),
105 (14, 'stock9', 0),
106 (15, 'stock10', 0),
107 (16, 'stock11', 4785),
108 (17, 'stock12', 0),
109 (19, 'stock6', 0),
110 (21, 'stock67', 770),
111 (22, 'stock673', 6773),
112 (23, 'stock56', 1905),
113 (24, 'sdds', 4758),
114 (25, 'adlfkji', 0),
115 (26, 'dlskfj', 7935),
116 (27, 'sdkfjsf', 48554),
117 (28, 'skdfj', 0),
118 (29, 'ksdf', 0),
119 (30, 'klsdjkfd', 0),
120 (31, '', 34);
121
122 -- --------------------------------------------------------
123
124 --
125 -- Table structure for table `stock_details`
126 --
127
128 CREATE TABLE `stock_details` (
129   `id` int(10) unsigned NOT NULL auto_increment,
130   `stock_id` varchar(120) NOT NULL,
131   `stock_name` varchar(120) NOT NULL,
132   `stock_quatity` int(11) NOT NULL,
133   `supplier_id` varchar(250) NOT NULL,
134   `company_price` smallint(6) NOT NULL,
135   `selling_price` smallint(6) NOT NULL,
136   `category` varchar(120) NOT NULL,
137   `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
138   `expire_date` varchar(50) NOT NULL,
139   `uom` varchar(120) NOT NULL,
140   PRIMARY KEY (`id`)
141 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
142
143 --
144 -- Dumping data for table `stock_details`
145 --
146
147 INSERT INTO `stock_details` (`id`, `stock_id`, `stock_name`, `stock_quatity`, `supplier_id`, `company_price`, `selling_price`, `category`, `date`, `expire_date`, `uom`) VALUES
148 (31, 'SD31', 'stock67', 0, 'supplier2', 45, 458, 'category3', '2010-02-26 19:37:39', '', ''),
149 (32, 'SD32', 'stock673', 0, 'supplier2', 45, 1245, 'category6', '2010-02-26 19:37:56', '', ''),
150 (33, 'SD33', 'stock56', 0, 'supplier2', 45, 78, 'category6', '2010-02-26 19:38:15', '', ''),
151 (35, 'SD35', 'adlfkji', 0, 'supplier3', 789, 32767, 'category3', '2010-02-26 19:58:33', '', ''),
152 (36, 'SD36', 'dlskfj', 0, 'sdkfj', 89, 9898, 'lkdsjf', '2010-02-26 19:58:40', '', ''),
153 (37, 'SD37', 'sdkfjsf', 0, '90909', 99, 90, 'skdjkjf', '2010-02-26 19:58:47', '', ''),
154 (38, 'SD38', 'skdfj', 0, 'kdsjf', 90, 90, 'dfkdjk', '2010-02-26 19:58:55', '', ''),
155 (39, 'SD39', 'ksdf', 0, 'sidjlfs', 90, 32767, 'kjsdf', '2010-02-26 19:59:02', '', '');
156
157 -- --------------------------------------------------------
158
159 --
160 -- Table structure for table `stock_entries`
161 --
162
163 CREATE TABLE `stock_entries` (
164   `id` int(10) unsigned NOT NULL auto_increment,
165   `stock_id` varchar(120) NOT NULL,
166   `stock_name` varchar(260) NOT NULL,
167   `stock_supplier_name` varchar(200) NOT NULL,
168   `category` varchar(120) NOT NULL,
169   `quantity` int(11) NOT NULL,
170   `company_price` int(11) NOT NULL,
171   `selling_price` int(11) NOT NULL,
172   `opening_stock` int(11) NOT NULL,
173   `closing_stock` int(11) NOT NULL,
174   `date` datetime NOT NULL,
175   `username` varchar(120) NOT NULL,
176   `type` varchar(50) NOT NULL,
177   `salesid` varchar(120) NOT NULL,
178   `total` int(11) NOT NULL,
179   `payment` int(11) NOT NULL,
180   `balance` int(11) NOT NULL,
181   `mode` varchar(150) NOT NULL,
182   `description` varchar(500) NOT NULL,
183   `due` datetime NOT NULL,
184   `subtotal` int(11) NOT NULL,
185   `count1` int(11) NOT NULL,
186   PRIMARY KEY (`id`)
187 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=141 ;
188
189 --
190 -- Dumping data for table `stock_entries`
191 --
192
193 INSERT INTO `stock_entries` (`id`, `stock_id`, `stock_name`, `stock_supplier_name`, `category`, `quantity`, `company_price`, `selling_price`, `opening_stock`, `closing_stock`, `date`, `username`, `type`, `salesid`, `total`, `payment`, `balance`, `mode`, `description`, `due`, `subtotal`, `count1`) VALUES
194 (121, 'SE1', 'stock673', '12455', '', 34, 45, 1245, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1530, 3555, 3000, 'cash', '', '2010-03-10 00:00:00', 3555, 1),
195 (122, 'SE1', 'stock67', '12455', '', 45, 45, 458, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 2025, 3555, 3000, 'cash', '', '2010-03-10 00:00:00', 3555, 2),
196 (123, 'SE123', 'stock67', '12455', '', 34, 45, 458, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1530, 4060, 0, 'cash', '', '2010-03-10 00:00:00', 3060, 1),
197 (124, 'SE123', 'stock56', '12455', '', 34, 45, 78, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1530, 4060, 0, 'cash', '', '2010-03-10 00:00:00', 3060, 2),
198 (125, 'SE125', 'stock673', '12455', '', 34, 45, 1245, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1530, 2530, 0, 'cash', '', '2010-03-10 00:00:00', 1530, 1),
199 (126, 'SA48', 'stock67', '', '', 34, 0, 0, 770, 736, '2010-03-10 00:00:00', 'admin', 'sales', 'SA48', 15572, 0, 0, '', '', '0000-00-00 00:00:00', 0, 0),
200 (127, 'SA49', 'stock67', '', '', 34, 0, 0, 736, 702, '2010-03-10 00:00:00', 'admin', 'sales', 'SA49', 15572, 0, 0, '', '', '0000-00-00 00:00:00', 0, 0),
201 (128, 'SA49', 'stock56', '', '', 34, 0, 0, 1905, 1871, '2010-03-10 00:00:00', 'admin', 'sales', 'SA49', 2652, 0, 0, '', '', '0000-00-00 00:00:00', 0, 0),
202 (129, 'SA49', 'stock673', '', '', 34, 0, 0, 6741, 6707, '2010-03-10 00:00:00', 'admin', 'sales', 'SA49', 42330, 0, 0, '', '', '0000-00-00 00:00:00', 0, 0),
203 (130, 'SA52', 'stock67', '', '', 34, 0, 0, 702, 668, '2010-03-10 00:00:00', 'admin', 'sales', 'SA52', 15572, 0, 0, '', '', '0000-00-00 00:00:00', 0, 0),
204 (131, 'SA52', 'adlfkji', '', '', 0, 0, 0, 0, 0, '2010-03-10 00:00:00', 'admin', 'sales', 'SA52', 0, 0, 0, '', '', '0000-00-00 00:00:00', 0, 0),
205 (134, 'SE132', 'stock67', '12455', '', 34, 45, 458, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1530, 7086, 86, 'cash', '', '2010-03-10 00:00:00', 6086, 1),
206 (135, 'SE132', 'stock56', '12455', '', 34, 45, 78, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1530, 7086, 86, 'cash', '', '2010-03-10 00:00:00', 6086, 2),
207 (136, 'SE132', 'dlskfj', '12455', '', 34, 89, 9898, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 3026, 7086, 86, 'cash', '', '2010-03-10 00:00:00', 6086, 3),
208 (137, 'SE137', 'stock67', '12455', '', 34, 45, 458, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1530, 3060, 1060, 'cash', '', '2010-03-10 00:00:00', 3060, 1),
209 (138, 'SE137', 'stock673', '12455', '', 34, 45, 1245, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1530, 3060, 1060, 'cash', '', '2010-03-10 00:00:00', 3060, 2),
210 (139, 'SE139', 'stock67', '12455', '', 34, 45, 458, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1530, 5940, 0, 'cash', 'fdg', '2010-03-10 00:00:00', 2970, 1),
211 (140, 'SE139', 'stock673', '12455', '', 32, 45, 1245, 0, 2010, '0000-00-00 00:00:00', 'admin', 'entry', '', 1440, 5940, 0, 'cash', 'fdg', '2010-03-10 00:00:00', 2970, 2);
212
213 -- --------------------------------------------------------
214
215 --
216 -- Table structure for table `stock_sales`
217 --
218
219 CREATE TABLE `stock_sales` (
220   `id` int(10) unsigned NOT NULL auto_increment,
221   `transactionid` varchar(250) NOT NULL,
222   `stock_name` varchar(200) NOT NULL,
223   `category` varchar(120) NOT NULL,
224   `supplier_name` varchar(200) NOT NULL,
225   `selling_price` smallint(6) NOT NULL,
226   `quantity` smallint(6) NOT NULL,
227   `amount` int(11) NOT NULL,
228   `date` datetime NOT NULL,
229   `username` varchar(120) NOT NULL,
230   `customer_id` varchar(120) NOT NULL,
231   `subtotal` int(11) NOT NULL,
232   `payment` int(11) NOT NULL,
233   `balance` int(11) NOT NULL,
234   `due` datetime NOT NULL,
235   `mode` varchar(250) NOT NULL,
236   `description` varchar(500) NOT NULL,
237   `count1` int(11) NOT NULL,
238   PRIMARY KEY (`id`)
239 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;
240
241 --
242 -- Dumping data for table `stock_sales`
243 --
244
245 INSERT INTO `stock_sales` (`id`, `transactionid`, `stock_name`, `category`, `supplier_name`, `selling_price`, `quantity`, `amount`, `date`, `username`, `customer_id`, `subtotal`, `payment`, `balance`, `due`, `mode`, `description`, `count1`) VALUES
246 (38, 'SA1', 'stock67', '', '', 458, 34, 15572, '2010-03-09 00:00:00', 'admin', 'customer2', 35266, 35266, 0, '2010-03-09 00:00:00', 'cash', '', 0),
247 (39, 'SA1', 'stock67', '', '', 458, 43, 19694, '2010-03-09 00:00:00', 'admin', 'customer2', 35266, 35266, 0, '2010-03-09 00:00:00', 'cash', '', 0),
248 (40, 'SA40', 'stock67', '', '', 458, 45, 20610, '2010-03-09 00:00:00', 'admin', 'customer2', 36182, 36182, 0, '2010-03-09 00:00:00', 'cash', '', 0),
249 (41, 'SA40', 'stock67', '', '', 458, 34, 15572, '2010-03-09 00:00:00', 'admin', 'customer2', 36182, 36182, 0, '2010-03-09 00:00:00', 'cash', '', 0),
250 (42, 'SA17', 'stock56', '', '', 78, 34, 2652, '2010-03-09 00:00:00', 'admin', 'customer2', 44982, 44982, 10554, '2010-03-03 00:00:00', 'cash', 'cash recevied by... concern person', 0),
251 (43, 'SA17', 'stock673', '', '', 1245, 34, 42330, '2010-03-09 00:00:00', 'admin', 'customer2', 44982, 44982, 10554, '2010-03-03 00:00:00', 'cash', 'cash recevied by... concern person', 0),
252 (44, 'SA44', 'stock673', '', '', 1245, 34, 42330, '2010-03-10 00:00:00', 'admin', 'customer245', 42330, 42330, 0, '2010-03-10 00:00:00', 'cash', 'fdgdfgdf', 0),
253 (45, 'SA44', 'stock67', '', '', 458, 0, 0, '2010-03-10 00:00:00', 'admin', 'customer245', 42330, 42330, 0, '2010-03-10 00:00:00', 'cash', 'fdgdfgdf', 0),
254 (46, 'SA46', 'stock67', '', '', 458, 34, 15572, '2010-03-10 00:00:00', 'admin', 'customer1', 57902, 57902, 0, '2010-03-10 00:00:00', 'cash', '', 0),
255 (47, 'SA46', 'stock673', '', '', 1245, 34, 42330, '2010-03-10 00:00:00', 'admin', 'customer1', 57902, 57902, 0, '2010-03-10 00:00:00', 'cash', '', 0),
256 (48, 'SA48', 'stock67', '', '', 458, 34, 15572, '2010-03-10 00:00:00', 'admin', 'customer1', 15572, 15572, 0, '2010-03-10 00:00:00', 'cash', '', 1),
257 (49, 'SA49', 'stock67', '', '', 458, 34, 15572, '2010-03-10 00:00:00', 'admin', 'customer1', 60554, 60554, 0, '2010-03-10 00:00:00', 'cash', '', 1),
258 (50, 'SA49', 'stock56', '', '', 78, 34, 2652, '2010-03-10 00:00:00', 'admin', 'customer1', 60554, 60554, 0, '2010-03-10 00:00:00', 'cash', '', 1),
259 (51, 'SA49', 'stock673', '', '', 1245, 34, 42330, '2010-03-10 00:00:00', 'admin', 'customer1', 60554, 60554, 0, '2010-03-10 00:00:00', 'cash', '', 1),
260 (52, 'SA52', 'stock67', '', '', 458, 34, 15572, '2010-03-10 00:00:00', 'admin', 'customer1', 15572, 15572, 10015, '2010-03-10 00:00:00', 'cash', '', 1),
261 (53, 'SA52', 'adlfkji', '', '', 32767, 0, 0, '2010-03-10 00:00:00', 'admin', 'customer1', 15572, 15572, 10015, '2010-03-10 00:00:00', 'cash', '', 1);
262
263 -- --------------------------------------------------------
264
265 --
266 -- Table structure for table `stock_user`
267 --
268
269 CREATE TABLE `stock_user` (
270   `id` int(10) unsigned NOT NULL auto_increment,
271   `username` varchar(120) NOT NULL,
272   `password` varchar(120) NOT NULL,
273   `user_type` varchar(20) NOT NULL,
274   PRIMARY KEY (`id`)
275 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
276
277 --
278 -- Dumping data for table `stock_user`
279 --
280
281 INSERT INTO `stock_user` (`id`, `username`, `password`, `user_type`) VALUES
282 (1, 'admin', 'admin', 'admin');
283
284 -- --------------------------------------------------------
285
286 --
287 -- Table structure for table `supplier_details`
288 --
289
290 CREATE TABLE `supplier_details` (
291   `id` int(10) unsigned NOT NULL auto_increment,
292   `supplier_name` varchar(200) NOT NULL,
293   `supplier_address` varchar(500) NOT NULL,
294   `supplier_contact1` varchar(100) NOT NULL,
295   `supplier_contact2` varchar(100) NOT NULL,
296   `balance` int(11) NOT NULL,
297   PRIMARY KEY (`id`)
298 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
299
300 --
301 -- Dumping data for table `supplier_details`
302 --
303
304 INSERT INTO `supplier_details` (`id`, `supplier_name`, `supplier_address`, `supplier_contact1`, `supplier_contact2`, `balance`) VALUES
305 (4, '12455', 'suppler1 address', '99520001152', '98437598', 3890);
306
307 -- --------------------------------------------------------
308
309 --
310 -- Table structure for table `transactions`
311 --
312
313 CREATE TABLE `transactions` (
314   `id` int(10) unsigned NOT NULL auto_increment,
315   `type` varchar(50) NOT NULL,
316   `customer` varchar(250) NOT NULL,
317   `supplier` varchar(250) NOT NULL,
318   `subtotal` int(11) NOT NULL,
319   `payment` int(11) NOT NULL,
320   `balance` int(11) NOT NULL,
321   `due` datetime NOT NULL,
322   `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
323   `rid` varchar(120) NOT NULL,
324   PRIMARY KEY (`id`)
325 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
326
327 --
328 -- Dumping data for table `transactions`
329 --
330
331 INSERT INTO `transactions` (`id`, `type`, `customer`, `supplier`, `subtotal`, `payment`, `balance`, `due`, `date`, `rid`) VALUES
332 (1, 'entry', '', '12455', 0, 0, 0, '0000-00-00 00:00:00', '2010-03-11 09:31:26', 'SE123'),
333 (2, 'entry', '', '12455', 0, 100, 900, '2010-03-10 00:00:00', '2010-03-11 09:39:19', 'SE125'),
334 (3, 'entry', '', '12455', 0, 900, 0, '2010-03-10 00:00:00', '2010-03-11 09:39:28', 'SE125'),
335 (4, 'entry', '', '12455', 6086, 1000, 86, '2010-03-10 00:00:00', '2010-03-11 09:42:00', 'SE132');
336
337 -- --------------------------------------------------------
338
339 --
340 -- Table structure for table `uom_details`
341 --
342
343 CREATE TABLE `uom_details` (
344   `id` int(10) unsigned zerofill NOT NULL auto_increment,
345   `name` varchar(120) NOT NULL,
346   `spec` varchar(120) NOT NULL,
347   PRIMARY KEY (`id`)
348 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
349
350 --
351 -- Dumping data for table `uom_details`
352 --
353
354 INSERT INTO `uom_details` (`id`, `name`, `spec`) VALUES
355 (0000000006, 'UOM1', 'UOM1 Specification'),
356 (0000000007, 'UOM2', 'UOM2 Specification'),
357 (0000000008, 'UOM3', 'UOM3 Specification'),
358 (0000000009, 'UOM4', 'UOM4 Specification');


Web, Tìm kết quả nhanh

Kích thước hoặc độ phức tạp của bản gửi này, tác giả đã gửi nó dưới dạng tệp .zip để rút ngắn thời gian tải xuống của bạn. Sau khi tải xuống, bạn sẽ cần một chương trình như Winzip để giải nén nó.

Tất cả các tệp đều được codefly.vn quét mỗi ngày một lần để tìm vi-rút, nhưng vi-rút mới xuất hiện hàng ngày nên không có chương trình phòng ngừa nào có thể bắt được 100% chúng.

ĐỂ AN TOÀN CỦA CHÍNH BẠN, VUI LÒNG:

1. Quét lại các tệp đã tải xuống bằng trình kiểm tra vi-rút cá nhân của bạn trước khi sử dụng.

2. KHÔNG BAO GIỜ, chạy các tệp đã biên dịch (.exe's, .ocx's, .dll's, v.v.)--chỉ chạy code mà bạn đã xem ít nhất 1 lần.

Official Website:

https://www.codewithc.com/.....ystem-project-java/

Gõ tìm kiếm nhanh...



Dự án liên quan!

Hệ thống đặt hàng đơn giản trong mã nguồn miễn phí Java

69 lượt xem

Ứng dụng quản lý liên hệ người dùng đơn giản bằng mã nguồn miễn phí Java

69 lượt xem

Java đổi quyền truy cập

973 lượt xem

Java Từ khóa final

610 lượt xem

Java Từ khóa this

586 lượt xem

Java Toán tử instanceof

711 lượt xem